Advance Your Knowledge Of Microsoft Excel!

If you're comfortable building a worksheet, using cells, entering data and creating basic formulas this program will take you to the next level of Excel expertise. Instead of hovering at the "tip of the iceberg", you'll drill down through Excel's complex capabilities and discover how easily you can expand your knowledge base to become a more confident, capable user.

This advanced Excel course is jam-packed with skills, tools, ideas and strategies gathered from professional users, tech experts and Excel gurus who know this application inside and out. This is practical Excel training you can put to use immediately once you've returned to the office. You'll understand concepts you may have struggled with in the past … become familiar with a broad range of advanced Excel capabilities and functions … and see your productivity soar as you use Excel more effectively and efficiently every day!What You'll Learn:Kick your skills up a notch in this one day advanced Excel training workshop and discover:

• A more in-depth knowledge of Excel's ribbon, menus and functions, including how to add your own tabs and groups
  
• Time-saving techniques to streamline data queries, data analysis and searches
  
• Tips for creating charts, graphs and tables that will wow your audience
  
• How to use PivotTable reports to filter and summarize your data and worksheets
  
• Scripts to automate repetitive tasks using macros
  
• A clear understanding of advanced filters so you extract only the information you need
  
• Menu options that allow you to select filtering criteria from your data set with just a few simple clicks
  
• The Analysis ToolPak add-in: how to fully utilize this resource for advanced data analysis
  
• The most effective methods to share spreadsheets with collaborators and coworkers
  
• And much more!